SUBSTR[ING]

Purpose

This function returns a substring of the length length from the position position, out of the string string.

Syntax

substring::=

Usage Notes

  • If length is not specified, all of the characters to the end of the string are used.
  • If position is negative, counting begins at the end of the string.
  • If position is 0 or 1, the result begins from the first character of the string.
  • MID is an alias for this function.
  • For additional information, refer to REGEXP_SUBSTR.

Example

SELECT SUBSTR('abcdef',2,3) S1,
       SUBSTRING('abcdef' FROM 4 FOR 2) S2
       ;
Result
S1 S2
bcd de